/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package utilidades;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

/**
 *
 * @author programador
 */

public class ConnectionFactory {
    
   public static Connection getConnection() throws Exception {
       
      String user = "root";
      String password = "mysql";
       
      try {
         Class.forName("com.mysql.jdbc.Driver");
         return DriverManager.getConnection("jdbc:mysql://localhost/sistema", user, password);
      }
      catch(Exception e) {
         throw new Exception(e.getMessage());    
      }
   
   }
   
   public static void closeConnection(Connection conn, Statement stmt, ResultSet rs) throws Exception {
      close(conn, stmt, rs);    
   }
   
   public static void closeConnection(Connection conn, Statement stmt) throws Exception {
      close(conn, stmt, null);    
   }
   
   public static void closeConnection(Connection conn) throws Exception {
      close(conn, null, null);    
   }
   
   public static void close(Connection conn, Statement stmt, ResultSet rs) throws Exception {
   
      try {
         if(rs != null) rs.close();
         if(stmt != null) stmt.close();
         if(conn != null ) conn.close();
      }
      catch(Exception e) {
         throw new Exception(e.getMessage());    
      }
       
   }

}